<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="gn143896">pg_available_extensions</title>
  <body>
    <p>The <codeph>pg_available_extensions</codeph> view lists the extensions that are available for
      installation. The <xref href="pg_extension.xml"><i>pg_extension</i></xref> system catalog
      table shows the extensions currently installed.</p>
    <p>The view is read only.</p>
    <table id="gn143898">
      <title>pg_catalog.pg_available_extensions</title>
      <tgroup cols="3">
        <colspec colnum="1" colname="col1" colwidth="131pt"/>
        <colspec colnum="2" colname="col2" colwidth="86pt"/>
        <colspec colnum="3" colname="col4" colwidth="147pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1"><codeph>name</codeph></entry>
            <entry colname="col2">name</entry>
            <entry colname="col4">Extension name.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>default_version</codeph></entry>
            <entry colname="col2">text</entry>
            <entry colname="col4">Name of default version, or <codeph>NULL</codeph> if none is
              specified.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>installed_version</codeph></entry>
            <entry colname="col2">text</entry>
            <entry colname="col4">Currently installed version of the extension, or
                <codeph>NULL</codeph> if not installed.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>comment</codeph></entry>
            <entry colname="col2">text</entry>
            <entry colname="col4">Comment string from the extension control file.</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
